home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr11
/
powerb5.zip
/
P5SPR002.TIP
< prev
next >
Wrap
Text File
|
1993-06-01
|
2KB
|
64 lines
To make life easy for your 1-2-3 users, try making a menu of
the macros available for use in a spreadsheet or spreadsheet
template. But for some people even this isn't enough; they
look at the menu and say Help! So I wrote a macro that lets
them bring up help screens when they need
explanations of the available choices. I usually create a
menu in the format shown below:
AA AB AC AD AE AF AG
1
2 Help is available on all menu choices. Hold down
3 <ALT> and press "H", then use the arrow keys to move
4 to the cell directly to the left of the menu choice
5 that you want help for. Once there, type "X" and
6 press <Enter> to go to the help screen for that choice.
7
8
9 <Alt+R>eturn to menu
10 <Alt+P>rint report
11 <Alt+S>ave worksheet with current data
12
Then I assign the range name MENU to a cell above, and to
the left of, the top of the menu. I assign the range name \0
(backslash zero) to a macro elsewhere on the worksheet that
reads {GOTO}MENU~. Since \0 executes automatically when the
spreadsheet is retrieved, users always start at the menu.
Before creating the help menu, I assign names to the cells
immediately to the left of the menu options; in this
particular example, I'd name cells AA9, AA10, and AA11
MENUX, PRINTX, and SAVEX, respectively. I'd then go to three
other out-of-the-way worksheet areas, type the actual help
text in those locations, and name those ranges MENUH,
PRINTH, and SAVEH. Finally, I would create a macro named \H,
as shown below, which displays the help text for any menu
entry that the user has marked with an X. The user is taken
to the appropriate help screen and can read it until he or
she presses <Enter>.
Bill Hartwell
Lyndonville, Vermont
Editor's Note: The macro below, which should be given the
name \H to work as described above, drives Mr. Hartwell's
menu system. The macro is also available -- for your
convenience -- as the file P5SPR\MENU.WK1 on your PowerBase
*.* Volume 5 diskette.
{GOTO}MENU~
{?}~
{IF @UPPER(MENUX)="X"}{GOTO}MENUH~Press <Enter>{?}{ESC}{GOTO}MENU~/REMENUX~
{IF @UPPER(PRINTX)="X"}{GOTO}PRINTH~Press <Enter>{?}{ESC}{GOTO}MENU~/REPRINTX~
{IF @UPPER(SAVEX)="X"}{GOTO}SAVEH~Press <Enter>{?}{ESC}{GOTO}MENU~/RESAVEX~
{QUIT}
Title: Help for 1-2-3 Macros
Category: SPR
Issue Date: March, 1992
Editor: Brett Glass
Supplementary Files: P5SPR\MENU.WK1
Filename: P5SPR002.TIP